package whf.framework.workflow.task;

/**
 * @author King
 *
 */
public class TaskManager {
	private final String TABLE_PREFFIX = "";
	public final String VIEW_SQL = "select sid_ as sid,t.entity_name_ as entityName,t.actorid_ as actorid,t.create_ as createDate,t.status_id_ as statusId,tn.id_ as nodeId,tn.name_ as nodeName from "+TABLE_PREFFIX+"jbpm_taskinstance t,"+TABLE_PREFFIX+"jbpm_task tk, "+TABLE_PREFFIX+"jbpm_node tn where t.task_=tk.id_ and tk.tasknode_=tn.id_ and t.actorid_ is not null " +
		" union select sid_ as sid,t.entity_name_ as entityName,ta.actorid_ as actorid,t.create_ as createDate,t.status_id_ as statusId,tn.id_ as nodeId,tn.name_ as nodeName " +  
		"from "+TABLE_PREFFIX+"jbpm_taskinstance t,"+TABLE_PREFFIX+"jbpm_task tk, "+TABLE_PREFFIX+"jbpm_node tn,"+TABLE_PREFFIX+"jbpm_taskactorPool tp,"+TABLE_PREFFIX+"jbpm_pooledactor ta where t.task_=tk.id_ and tk.tasknode_=tn.id_ and t.id_=tp.taskinstance_ and tp.pooledactor_=ta.id_ and t.actorid_ is null  " ;
	
}
